package tech.aistar.mapper.collecte;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tech.aistar.entity.Collectes;

import java.util.List;


/**
 * Created by Administrator on 2019/9/28 0028.
 */
@Repository
public interface CollecteViewMapper {
    //视图表，做查询，根据收藏表
    @Select("select * from collectes where id=#{value}")
    List<Collectes> colviewFindAll(Integer id);

    @Select("select * from collectes")
    List<Collectes> colFindAll();

    @Select("select * from collectes where userinfo_id=#{value}")
    List<Collectes> colViewFindOne(Integer userinfoId);

    @Select("select * from collectes where services_id=#{value}")
    List<Collectes> serviceFind(Integer servicesId);

}
